﻿CREATE TABLE [dbo].[CourseSemester]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [CourseId] INT NOT NULL, 
    [SemesterId] INT NOT NULL, 
    [Time] DATETIME NULL, 
    [Lecture] NVARCHAR(250) NULL, 
    [DoctorId] INT NOT NULL, 
    [SectionOrLecture] NVARCHAR(50) NULL, 
    CONSTRAINT [FK_CourseSemester_ToCourses] FOREIGN KEY ([CourseId]) REFERENCES [Courses]([ID]), 
    CONSTRAINT [FK_CourseSemester_ToSemester] FOREIGN KEY ([SemesterId]) REFERENCES [Semester]([Id]), 
    CONSTRAINT [FK_CourseSemester_ToDoctor] FOREIGN KEY ([DoctorId]) REFERENCES [Doctor]([ID])
)
